话不多说,看代码和注释
分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();
}
}
}