addwebs.java

可以java程序实现与SQLserver数据库的连接

import java.sql.*;
import javax.servlet.*;
import javax.servlet.http.*;
import java.io.*;

public class addwebs extends HttpServlet {
	public void service(HttpServletRequest rq, HttpServletResponse rp)
			throws ServletException, IOException {
		rq.setCharacterEncoding("GB2312");
		rp.setContentType("text/html; charset=gb2312");
		PrintWriter out = rp.getWriter();
		String nm = new String(rq.getParameter("xx"));
		String ag = new String(rq.getParameter("yy"));
		String dp = new String(rq.getParameter("zz"));
		System.out.println(nm + ag + dp);
		try {
			DriverManager.registerDriver(new sun.jdbc.odbc.JdbcOdbcDriver());
			// myd 是前面配置数据库时给数据源所起的名称
			Connection con = DriverManager.getConnection("jdbc:odbc:mydatabase");
			Statement stmt = con.createStatement();
			System.out.println("1");
			// 注意单引号和双引号
			// 这里目的是利用传入的变量生成类似如下的SQL语句
			// insert into my values('张三', 20, '软件部');
			String s = "insert into student values('" + nm + "','" + ag + "','"
					+ dp + "')";
			System.out.println(s);// 在Servlet窗口监控执行的语句
			stmt.executeUpdate(s);
			System.out.println("2");
		} catch (Exception e) {
		}
		out.println("Thank you");
	}
}