ASP.NET与JSP 连接SQL Server基本操作

最新推荐文章于 2024-09-19 13:53:40 发布

原创最新推荐文章于 2024-09-19 13:53:40 发布 · 738 阅读

0 ·

CC 4.0 BY-SA版权

ASP.NET|JSP 专栏收录该内容

2 篇文章

订阅专栏

本文提供了一个使用C#的ASP.NET应用程序示例，展示了如何连接到SQL Server并从数据库中读取数据填充网格视图。同时，还提供了一个Java JSP示例，演示了如何插入和查询数据库。

<span style="font-family: Arial, Helvetica, sans-serif; background-color: rgb(255, 255, 255);">Asp.net  coding by C#</span>
[code=c#]

public partial class WebForm1 : System.Web.UI.Page
    {
        private 
        SqlConnection _con;
        SqlDataReader _read;
 
        protected void Page_Load(object sender, EventArgs e)
        {
           
            const string connStr = "Data Source=.;Database=TestCoolsir;Integrated Security=false;Uid=sa;Password=**********;";
            const string strSql = "select * from TestCoolsir";
            SqlCommand cmd;
     
            _con = new SqlConnection(connStr);
            _con.Open();
            using(cmd=new SqlCommand(strSql,_con))
            {
                using (_read = cmd.ExecuteReader())
                {
                    GridView1.DataSource = _read;
                    GridView1.DataBind();
                }
            }
           
            _con.Close();
 
        }
}
Jsp coding by Java
Jsp coding by Java
[code=Java]
import java.sql.ResultSet;
import java.text.SimpleDateFormat;
import java.util.Date;
 public static ResultSet showanything(String name,String message) 
 {
  java.sql.Connection conn;java.sql.Statement stmt;java.sql.ResultSet res=null;
  try
  {
   Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver").newInstance();//
   conn= java.sql.DriverManager.getConnection("jdbc:sqlserver://localhost:1433;DatabaseName=TestCoolsir","sa","**********");
   stmt = conn.createStatement();
   SimpleDateFormat df = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");//set time format
   String time=df.format(new Date());// new Date()get now time
   String query="select * from MessageBoard";
   String everquery="insert into MessageBoard (UserName,NetTime,Messages) values ("+"'"+name+"','"+time+"','"+message+"')";
   stmt.executeUpdate(everquery);//write a line to Database;
    res =stmt.executeQuery(query);//read sql query from Database;
  }
  catch (java.sql.SQLException e){
   System.out.println(e.toString());
   } catch (InstantiationException e) {
   // TODO Auto-generated catch block
   e.printStackTrace();
  } catch (IllegalAccessException e) {
   // TODO Auto-generated catch block
   e.printStackTrace();
  } catch (ClassNotFoundException e) {
   // TODO Auto-generated catch block
   e.printStackTrace();
  } 
    
  return res;
 }
 
[/code]

<code>
//这些链接SQL server数据库;
//留作记录举一反三;
//SQL server 2012;</code>