首先JDBC的前期数据库数据准备:
1,打开链接好MySQL的Workbench软件,新建一个数据库:
![](http://images2015.cnblogs.com/blog/784420/201510/784420-20151003005549824-2051401842.png?x-oss-process=image/resize,w_1400/format,webp)
![](http://images2015.cnblogs.com/blog/784420/201510/784420-20151003005723183-271962992.png?x-oss-process=image/resize,w_1400/format,webp)
![](http://images2015.cnblogs.com/blog/784420/201510/784420-20151003005738918-596253321.png?x-oss-process=image/resize,w_1400/format,webp)
2、然后打开数据库对应的代码编辑窗口,建立表和插入数据记录:
![](http://images2015.cnblogs.com/blog/784420/201510/784420-20151003005750590-580514450.png?x-oss-process=image/resize,w_1400/format,webp)
![](http://images2015.cnblogs.com/blog/784420/201510/784420-20151003005852136-1648699647.png?x-oss-process=image/resize,w_1400/format,webp)
![](http://images2015.cnblogs.com/blog/784420/201510/784420-20151003005902652-1232492244.png?x-oss-process=image/resize,w_1400/format,webp)
![](http://images2015.cnblogs.com/blog/784420/201510/784420-20151003005927215-1336099477.png?x-oss-process=image/resize,w_1400/format,webp)
![](http://images2015.cnblogs.com/blog/784420/201510/784420-20151003005941933-1975913899.png?x-oss-process=image/resize,w_1400/format,webp)
![](http://images2015.cnblogs.com/blog/784420/201510/784420-20151003005952199-1538962375.png?x-oss-process=image/resize,w_1400/format,webp)
![](http://images2015.cnblogs.com/blog/784420/201510/784420-20151003010005730-399632139.png?x-oss-process=image/resize,w_1400/format,webp)
3、然后是打开关于javaWeb编程的Eclipse,然后把数据库链接的jar包拷贝进去,然后加载jar文件
![](http://images2015.cnblogs.com/blog/784420/201510/784420-20151003010034199-1760667221.png?x-oss-process=image/resize,w_1400/format,webp)
![](http://images2015.cnblogs.com/blog/784420/201510/784420-20151003010128418-531280331.png?x-oss-process=image/resize,w_1400/format,webp)
![](http://images2015.cnblogs.com/blog/784420/201510/784420-20151003010134621-684894462.png?x-oss-process=image/resize,w_1400/format,webp)
![](http://images2015.cnblogs.com/blog/784420/201510/784420-20151003010140777-190245434.png?x-oss-process=image/resize,w_1400/format,webp)
4、然后开始进行JDBC编程:
![](http://images2015.cnblogs.com/blog/784420/201510/784420-20151003010159824-1473627793.png?x-oss-process=image/resize,w_1400/format,webp)
![](http://images2015.cnblogs.com/blog/784420/201510/784420-20151003010221824-1046369099.png?x-oss-process=image/resize,w_1400/format,webp)
![](http://images.cnblogs.com/OutliningIndicators/ExpandedBlockStart.gif?x-oss-process=image/resize,w_1400/format,webp)
![复制代码](http://common.cnblogs.com/images/copycode.gif?x-oss-process=image/resize,w_1400/format,webp)
1 import java.sql.DriverManager; 2 import java.sql.ResultSet; 3 import java.sql.Connection; 4 import java.sql.Statement; 5 6 //import com.mysql.jdbc.Connection; 7 //import com.mysql.jdbc.Statement;//注意不是mysql里的代码 8 9 public class JDBCTest { 10 public static void main(String[] args) { 11 //1字符串保存一条SQL语句 12 String sql = "SELECT * FROM tbl_user"; 13 //2Connection表示当前数据库的连接 14 Connection conn = null; 15 //3Statement用于向数据库发送SQL语句 16 Statement st = null; 17 //4ResultSet代表结果值,封装了从数据库中查询到的数据 18 ResultSet rs = null; 19 20 //5 21 try { 22 //forName用来初始化参数指定的类,参数中的字符串是mysql中的驱动程序 23 Class.forName("com.mysql.jdbc.Driver"); 24 //接下来的代码是获取数据库的连接,三个参数:访问数据的url,数据库的管理员用户名,数据库登入密码 25 conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/jsp_db","root",""); 26 st = conn.createStatement(); 27 rs = st.executeQuery(sql);//发送sql语句 28 29 while (rs.next()) { 30 //获取对应字段的数据内容 31 System.out.print(rs.getInt("id")+" "); 32 System.out.print(rs.getString("name")+" "); 33 System.out.print(rs.getString("password")+" "); 34 System.out.print(rs.getString("email")+" "); 35 System.out.println(); 36 } 37 } catch (Exception e) { 38 //打印异常信息 39 e.printStackTrace(); 40 }finally { 41 //最后要执行清理的工作,按照由小到大的顺序进行关闭的 42 try { 43 rs.close(); 44 } catch (Exception e2) { 45 } 46 try { 47 st.close(); 48 } catch (Exception e2) { 49 } 50 try { 51 conn.close(); 52 } catch (Exception e2) { 53 } 54 } 55 //这样代码就写完毕了 56 } 57 }
![复制代码](http://common.cnblogs.com/images/copycode.gif?x-oss-process=image/resize,w_1400/format,webp)
![](http://images2015.cnblogs.com/blog/784420/201510/784420-20151003010536699-1777648005.png?x-oss-process=image/resize,w_1400/format,webp)