java 使用jdbc 链接数据库

话不多说，看代码和注释

分5步 1 查找驱动 2 连接数据库 3 查询 4 提交事务 5 关闭链接

ResultSet rec = st.executeQuery(sqlList);

int rta = st.executeUpdate(sqlStr);

package jdbcttest;

import java.sql.Connection;import java.sql.DriverManager;import java.sql.ResultSet;import java.sql.SQLException;import java.sql.Statement;import com.mysql.jdbc.Driver;

public class JdbcTest { public static void main(String[] args){  String dbDriver ="com.mysql.jdbc.Driver";  String url="jdbc:mysql://localhost:3306/test";  String userName="root";  String password="hello";    try {   //1 查找驱动   Class.forName(dbDriver).newInstance();   //2 设置url 链接mysql    Connection  conn = DriverManager.getConnection(url,userName,password);   Statement st = conn.createStatement();   //3执行查询   String sqlList = "select * from news_table";   ResultSet rec = st.executeQuery(sqlList);   System.out.println(rec.getRow());   //4提交事务数据   String sqlStr = "insert into news_table values (57,'insert')";    int rta = st.executeUpdate(sqlStr);    conn.setAutoCommit(false);    conn.commit();    if(rta>0){     System.out.println("update 运行成功");    }    //5 关闭链接   if(st!= null){       st.close();   }   if(!conn.isClosed()){    conn.close();   }  } catch (InstantiationException e) {   e.printStackTrace();  } catch (IllegalAccessException e) {   // TODO Auto-generated catch block   e.printStackTrace();  } catch (ClassNotFoundException e) {   // TODO Auto-generated catch block   e.printStackTrace();  }catch (SQLException e) {   // TODO Auto-generated catch block   e.printStackTrace();  }   }

}