#java从头再来#Servlet+JDBC+MYSQL

来源：互联网发布：程序员代码面试指南编辑：程序博客网时间：2024/04/27 13:45

用过各种框架(Spring mvc, Hibernate, iBatis)之后，突然手写JDBC的操作数据库可能完全不知道下手。

JDBC+MySQL 需要使用到的jar包（mysqljdbc.jar 详见：https://cn.jarfire.org/ 收录几千个jar包，只有你想不到的，没有你找不到的。）

JDBCConnection

package com.lesson002.db;import java.sql.Connection;import java.sql.DriverManager;import java.sql.Statement;public class MyDB {private final String DBDRIVER="com.mysql.jdbc.Driver";private final String DBURL="jdbc:mysql://localhost:3306/test";private final String DBUSER="root";private final String DBPWD="root";private Connection conn = null;private static Statement stmt = null;public MyDB(){try {Class.forName(DBDRIVER);conn = DriverManager.getConnection(DBURL, DBUSER, DBPWD);} catch (Exception e) {// TODO: handle exception}}public Connection getConnection(){return this.conn;} public void close(){try {this.conn.close();} catch (Exception e) {// TODO: handle exception}}public int doInsert(String sql){try {stmt = conn.createStatement();int i = stmt.executeUpdate(sql);return i;} catch (Exception e) {// TODO Auto-generated catch blocke.printStackTrace();}return 0;}}

Dao

package com.lesson002.db;public class Dao {public int addScore(){try {MyDB db = new MyDB();int i = db.doInsert("insert into score(stucode, lessonno, score) values('50010','50010','59')");db.close();return i;} catch (Exception e) {// TODO Auto-generated catch blocke.printStackTrace();}return 0;}}

注：其他数据库操作不做举例

0 0