不用数据源,MYSQL的如下:
package datas;import java.sql.*;public class condb
{
java.sql.Connection conn;
java.sql.Statement stmt;
java.sql.ResultSet rs;
public condb()
{
try
{
Class.forName("org.gjt.mm.mysql.Driver");
}
catch(java.lang.ClassNotFoundException e)
{
System.err.println(e.getMessage());
}
}
public java.sql.ResultSet executeQuery(String sql)
{
rs = null;
try
{
conn = java.sql.DriverManager.getConnection("jdbc:mysql://localhost:3306/consumer","root","");
stmt = conn.createStatement();
rs = stmt.executeQuery(sql);
}
catch(SQLException ex)
{
System.err.println("aq.executeQuery:"+ex.getMessage());
}
return rs;
}
}
package datas;import java.sql.*;public class condb
{
java.sql.Connection conn;
java.sql.Statement stmt;
java.sql.ResultSet rs;
public condb()
{
try
{
Class.forName("org.gjt.mm.mysql.Driver");
}
catch(java.lang.ClassNotFoundException e)
{
System.err.println(e.getMessage());
}
}
public java.sql.ResultSet executeQuery(String sql)
{
rs = null;
try
{
conn = java.sql.DriverManager.getConnection("jdbc:mysql://localhost:3306/consumer","root","");
stmt = conn.createStatement();
rs = stmt.executeQuery(sql);
}
catch(SQLException ex)
{
System.err.println("aq.executeQuery:"+ex.getMessage());
}
return rs;
}
}
package 包名;import javax.servlet.*;
import javax.servlet.http.*;
import java.io.*;
import java.sql.*;public class Insert_infot extends HttpServlet { //Initialize global variables
public void init() throws ServletException {
} //Process the HTTP Post request
public void doGet(HttpServletRequest request, HttpServletResponse aa) throws ServletException, IOException {
StringBuffer buf=new StringBuffer();
buf.append("insert studty values('");
//接受传递过来的姓名
buf.append(trf(request.getParameter("name")));
buf.append("','");
//接受传递过来的密码
buf.append(request.getParameter("password"));
buf.append("','");
//接受传递过来的
buf.append(request.getParameter("address"));
buf.append("','"); //接受传递过来的
buf.append(request.getParameter("pho"));
buf.append("')");
System.out.println("buf="+buf.toString());
String url="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=mydb";
try {
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance();
Connection con=DriverManager.getConnection(url,"xgd","xgd");
Statement stm=con.createStatement();
stm.executeUpdate(buf.toString());
stm.close();
con.close();
aa.sendRedirect("index.jsp");
}
catch (Exception ex) {
} }
public String trf(String str){
try {
return new String(str.getBytes("ISO-8859-1"), "GB2312");
}
catch (UnsupportedEncodingException ex) {
return null;
}
}
//Clean up resources
public void destroy() {
}
}
{
public static void main(String args[])
{
try
{
String data = "jdbc:microsoft:sqlserver://192.168.0.99:1433;DatabaseName=northwind";
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver"); //"sun.jdbc.odbc.JdbcOdbcDriver");
Connection con = DriverManager.getConnection(data,"sa","");
Statement stm = con.createStatement();
ResultSet rs = stm.executeQuery("select * from employees");
while(rs.next())
{
System.out.println (rs.getString(1)+"\t"+rs.getString(2)+"\t"+rs.getString(3));
}
}
catch (Exception ex)
{
System.out.println (ex.toString());
}
}
}要配置好SQL SERVER2000 的驱动