数据库的CRUD sql 之插入数据
* insert
完整代码:
JDBCUtil.java
package com.jdbc.util;
import java.io.FileInputStream;
import java.io.FileNotFoundException;
import java.io.IOException;
import java.io.InputStream;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.Properties;
import org.xml.sax.InputSource;
public class JDBCUtil {
static String driverClass = null;
static String url = null;
static String username = null;
static String password =null;
static{
try {
//1. 创建一个属性配置对象
Properties properties = new Properties();
InputStream is = new FileInputStream("jdbc.properties"); //对应文件位于工程根目录
//使用类加载器,去读取src底下的资源文件。 后面在servlet //对应文件位于src目录底下
// InputStream is = JDBCUtil.class.getClassLoader().getResourceAsStream("jdbc.properties");
//导入输入流。
properties.load(is);
//读取属性
driverClass = properties.getProperty("driverClass");
url = properties.getProperty("url");
username = properties.getProperty("username");
password = properties.getProperty("password");
} catch (Exception e) {
e.printStackTrace();
}
}
//获取链接对象
public static Connection getConn() {
Connection conn=null;
try {
//1.注册驱动
Class.forName(driverClass);
//2.建立连接,参数(协议:访问的数据库、用户名、密码)
conn = DriverManager.getConnection(url, username, password);
} catch (Exception e) {
e.printStackTrace();
}
return conn;
}
/*释放资源*/
public static void release(Connection conn,Statement st,ResultSet rs) {
closeRs(rs);
closeSt(st);
closeConn(conn);
}
//方法重载
public static void release(Connection conn,Statement st) {
closeSt(st);
closeConn(conn);
}
private static void closeRs(ResultSet rs) {
try {
if(rs != null) {
rs.close();
}
} catch (SQLException e) {
e.printStackTrace();
}finally {
rs = null;
}
}
private static void closeSt(Statement st) {
try {
if(st != null) {
st.close();
}
} catch (SQLException e) {
e.printStackTrace();
}finally {
st = null;
}
}
private static void closeConn(Connection conn) {
try {
if(conn != null) {
conn.close();
}
} catch (SQLException e) {
e.printStackTrace();
}finally {
conn = null;
}
}
}
TestDemo.java
package com.jdbc.test;
import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.Statement;
import org.junit.Test;
import com.jdbc.util.JDBCUtil;
//使用junit执行查询单元
public class TestSDemo {
@Test
public void testQuery(){
//查询
Connection conn = null;
Statement st = null;
ResultSet rs = null;
try {
// 1.获取连接对象
conn = JDBCUtil.getConn();
// 2.根据连接对象,得到statement
st = conn.createStatement();
/*// 3.执行sql语句,返回ResultSet
String sql = "select * from t_stu";
rs = st.executeQuery(sql);*/
// 3.执行sql语句,返回ResultSet
String sql = "insert into t_stu values (null,'zhaoliu',59)";
int result = st.executeUpdate(sql);//返回影响的行数
/*// 4.遍历结果
while (rs.next()) {
String name = rs.getString("name");
int age = rs.getInt("age");
System.out.println(name + "...." + age);
}*/
if(result > 0) {
System.out.println("添加成功");
} else {
System.out.println("添加失败");
}
} catch (Exception e) {
e.printStackTrace();
} finally {
JDBCUtil.release(conn, st);
}
}
}