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

来源：互联网发布：mac文件夹图片用照片编辑：程序博客网时间：2024/05/17 07:03

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

0 0