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

<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>