首先是 獲取值頁面My.jsp 源碼:
<%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%>
<%
String path = request.getContextPath();
String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<base href="<%=basePath%>">
<title>My JSP 'My.jsp' starting page</title>
<meta .mysql.jdbc.Driver"; //驅動類位置
String username = "root"; //數據庫登錄名稱,此處寫上妳的用戶名稱
String pwd = "root"; //數據庫登錄密碼,此處寫上妳的登錄密碼
try
{
Class.forName(driver);
con = DriverManager.getConnection(url, username, pwd); //創建Connection連接對象
stm = con.createStatement(); //創建Statement 命令執行對象
}
catch (ClassNotFoundException e)
{
// TODO Auto-generated catch block
e.printStackTrace();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
String name=request.getParameter("name"); //獲取傳過來的名稱
String password=request.getParameter("password");//獲取傳過來的密碼
String sql="insert into user(name,password) values("+name+","+password+")";//數據庫添加壹條記錄sql語句
int temp=stm.executeUpdate(sql);
if(temp>0)
{
out.print("添加成功");
}
else
{
out.print("添加失敗");
}
//關閉數據庫連接
stm.close();
con.close();
%>
</body>
</html>
註意 連接不同數據庫要導入不同的數據庫驅動包 妳要導入才行啊
附 sqlserver數據庫連接 部分關鍵代碼:
private static Connection con = null;
private static Statement stm = null;
private static String url = "jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=數據庫名稱";
private static String driver = "com.microsoft.jdbc.sqlserver.SQLServerDriver";//與mysql有所不同
private static String username = "sa";//默認用戶
private static String pwd = "123"; //密碼
static {
try {
Class.forName(driver);
con = DriverManager.getConnection(url, username, pwd);
System.out.print("連接成功!");
stm = con.createStatement();
} catch (ClassNotFoundException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}