jdbc 数据库连接验证 工具

加入相应的数据库驱动包
验证代码如下：

package com.study.jdbc;import java.sql.*;public class Mysql {    //public static final String DBDRIVER ="oracle.jdbc.OracleDriver";//oracle    //public static final String DBDRIVER ="com.microsoft.sqlserver.jdbc.SQLServerDriver";//sqlserver    //public static final String DBDRIVER ="org.postgresql.Driver";//symfoware open,powergres plus    //public static final String DBDRIVER ="com.fujitsu.symfoware.jdbc.SYMDriver";//symfoware native    //public static final String DBDRIVER = "org.gjt.mm.mysql.Driver";        public static final String DBDRIVER = "com.mysql.jdbc.Driver";        //把SC换成你要连接的数据库的名字        public static final String DBURL = "jdbc:mysql://localhost:3306/mytest"; //mysql        //public static final String DBURL ="jdbc:oracle:thin:@10.167.157.157:1521:fnstdb2";//oracle        //public static final String DBURL ="jdbc:sqlserver://193.168.250.221:1433;DatabaseName=db02";//sqlserver        //public static final String DBURL ="jdbc:postgresql://10.167.133.112:26500/db01"; //symfoware open        //public static final String DBURL ="jdbc:symford://193.168.228.221:26551/db01;schema=EJB"; //symfoware native        //public static final String DBURL ="jdbc:postgresql://193.168.250.221:5432/postgres"; //powergres plus        public static final String DBUSER = "root";   //user_name代表数据库用户的名称        public static final String DBPASS = "911";   //user_password代表你对连接用户设置的密码        public static void main(String[] args) {            PreparedStatement ps1 = null;            PreparedStatement ps2 = null;            PreparedStatement ps3 = null;            PreparedStatement ps4 = null;            PreparedStatement ps5 = null;//          Statement st = null;            Connection ct = null;            ResultSet rs1 = null;            ResultSet rs2 = null;            try {                Class.forName(DBDRIVER);         //把驱动程序加载到jvm中去                ct = DriverManager.getConnection(DBURL, DBUSER, DBPASS);   //取得数据库的一个连接对象                if(ct!=null){                System.out.println("连接成功！");                }                           //native//              String sql1 = "DROP TABLE PERSON CASCADE";//              String sql2 = "CREATE TABLE PERSON (PERSONID INTEGER NOT NULL PRIMARY KEY, PERSONNAME VARCHAR(32) NOT NULL)";//              String sql3 = "CREATE INDEX PERSON.IXA KEY(PERSONID)";//              String sql4 = "INSERT INTO PERSON(PERSONID, PERSONNAME) VALUES(1,'tong')";                String sql1 = "DROP TABLE IF EXISTS PERSON";                String sql2 = "CREATE TABLE PERSON (PERSONID INTEGER NOT NULL PRIMARY KEY, PERSONNAME VARCHAR(32) NOT NULL)";                String sql3 = "INSERT INTO PERSON(PERSONID, PERSONNAME) VALUES(1,'tong')";                String sql4 = "SELECT *FROM PERSON";                String sql5 = "UPDATE PERSON SET PERSONNAME = 'CHX' where PERSONID = 1";                ps1 = ct.prepareStatement(sql1);                ps2 = ct.prepareStatement(sql2);                ps3 = ct.prepareStatement(sql3);                ps4 = ct.prepareStatement(sql4);                ps5 = ct.prepareStatement(sql5);                ps1.executeUpdate();                 System.out.println("表删除成功！");                ps2.executeUpdate();                 System.out.println("表创建成功！");                ps3.executeUpdate();                 System.out.println("数据插入成功！");                rs1=ps4.executeQuery();                 System.out.println("数据表查询成功！");                                 System.out.println("表中内容如下：");                 while(rs1.next())                {                    System.out.println(rs1.getString(1) + " "                            +rs1.getString(2)+ " "//                          +rs.getString(3)+ " "//                          +rs.getString(4)+ " "                            );                }                   //表更新之后                ps5.executeUpdate();                 System.out.println("表更新成功！");                 rs2=ps4.executeQuery();                 System.out.println("数据表查询成功！");                                 System.out.println("表中内容如下：");                 while(rs2.next())                {                    System.out.println(rs2.getString(1) + " "                            +rs2.getString(2)+ " "//                          +rs.getString(3)+ " "//                          +rs.getString(4)+ " "                            );                }               }catch(Exception e){                e.printStackTrace();                System.out.println("连接失败!");            }finally{                //关闭                try {                    if(rs1!=null) rs1.close();                      if(rs2!=null) rs2.close();                    if(ps1!=null) ps1.close();                    if(ps2!=null) ps2.close();                    if(ps3!=null) ps3.close();                    if(ps4!=null) ps4.close();//                  if(st!=null) st.close();                    if(ct!=null) ct.close();                } catch (Exception e) {                    // TODO: handle exception                    e.printStackTrace();                }            }                   }    }