1、導入jar包(將jar包復制到Webcontent 下的web-inf文件夾，右鍵包名晨炕，選擇Build path,選擇add path)
mysql-connector-java-5.1.7-bin.jar
2掏愁、在doGet下寫入以下代碼歇由，實現(xiàn)數(shù)據(jù)表的一條數(shù)據(jù)添加，如果添加成功則在屏幕輸出添加成功果港，添加失敗則輸出添加失敗沦泌。
protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
//修改編碼
response.setContentType("text/html;charset=UTF-8");
request.setCharacterEncoding("UTF-8");
try {
//加載類代碼的時候會執(zhí)行類中的靜態(tài)代碼
//1、創(chuàng)建一個驅動對象并注冊到驅動管理器中
Class.forName("com.mysql.jdbc.Driver");
//2辛掠、創(chuàng)建一個鏈接對象連接數(shù)據(jù)庫
Connection conn=DriverManager.getConnection("jdbc:mysql://localhost:3306/數(shù)據(jù)表名","數(shù)據(jù)庫用戶名","數(shù)據(jù)庫密碼");
//3谢谦、創(chuàng)建聲明對象（語句命令對象）傳sql語句到數(shù)據(jù)庫
Statement statement = conn.createStatement();
//4、執(zhí)行sql語句
String sql = "insert into mymarket values('hello', '123')";
int i = statement.executeUpdate(sql);
//5萝衩、處理結果
if(i>0)
response.getWriter().println("添加成功");
else
response.getWriter().println("添加失敗");
//6回挽、關閉連接
statement.close();
conn.close();
} catch (ClassNotFoundException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
3、如果是更新操作猩谊，則將sql語句變?yōu)?/p>
String sql = "update mymarket set userPassword='***' where userName='***'";
4千劈、如果是刪除操作，則將sql語句變?yōu)?/p>
String sql = "delete from mymarket where userName='***'";//刪除語句
