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