1. asp + MSSQL
Using System.Data.SqlClient;
string [email protected] "Data source=20131231-0936\sqlexpress;initial catalog=czcjc;integrated security=true";
SqlConnection con=new SqlConnection (SQLSTR);
SqlCommand cmd=new SqlCommand ();
Cmd. Connection=con;
Sqlstr= "SELECT * from CZCJC";
CMD.COMMANDTEXT=SQLSTR;
Conn. Open ();
DataTable dt=new DataTable ();
SqlDataAdapter Da=new SqlDataAdapter ();
Da. Selectcommand=cmd;
Da. Fill (DT);
2. asp + Oracle
Using System.Data.OracleClient;
String orastr= "Data source=czc; User Id=system; Password=wzfsystem; Unicode=true ";
OracleConnection con=new OracleConnection (ORASTR);
OracleCommand cmd=new OracleCommand ();
Cmd. Connection=con;
Orastr= "SELECT * from CZCJC";
CMD.COMMANDTEXT=ORASTR;
Conn. Open ();
DataTable dt=new DataTable ();
OracleDataAdapter da=new OracleDataAdapter (str,conn);
Da. Selectcommand=cmd;
Da. Fill (DT);
3. JSP + MSSQL
4. JSP + Oracle