package com.neusoft.text;
import java.sql.Connection;
import java.sql.Date;
import java.sql.PreparedStatement;
public class JdbcInsertTest {
public static void main(String[] args) {
try {
Connection con=JDBCUils.getConnection();
PreparedStatement pst=con.prepareStatement("insert into users(id,name,password1,email,birthday) "
+ "values(1101,'daming','111111','111111145124@qq.com','1111.01.19'),(1102,'aaaa','11457','1777775124@qq.com','1991.01.19')");
int rows=pst.executeUpdate();
pst.close();
con.close();
} catch (Exception e) {
e.printStackTrace();
}
}
}
package com.neusoft.text;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
public class FindAllUserTest {
public static void main(String[] args) {
try {
Connection con=JDBCUils.getConnection();
Statement state=con.createStatement();
ResultSet rs=state.executeQuery("select*from users");
while(rs.next()) {
System.out.println(rs.getInt("id")+","+rs.getString("name")+","+rs.getString("password1")+","+rs.getString("email")+","+rs.getString("birthday"));
}
//关闭连接
rs.close();
state.close();
con.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}
package com.neusoft.text;
import java.sql.Connection;
import java.sql.Date;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
public class FindUserByIdTest {
public static void main(String[] args) {
try {
Connection con=JDBCUils.getConnection();
Statement state=con.createStatement();
ResultSet rs=state.executeQuery("select*from users where id=1101");
while(rs.next()) {
System.out.println(rs.getInt("id")+","+rs.getString("name")+","+rs.getString("password1")+","+rs.getString("email")+","+rs.getString("birthday"));
}
//关闭连接
rs.close();
state.close();
con.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}
package com.neusoft.text;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.Statement;
public class UpdateUserTest {
public static void main(String[] args) {
try {
Connection con=JDBCUils.getConnection();
Statement state= con.createStatement();
int rows=state.executeUpdate("update users set email='1547845124@bb.com' where id=1101 ");
con.close();
state.close();
} catch (Exception e) {
e.printStackTrace();
}
}
}
package com.neusoft.text;
import java.sql.Connection;
import java.sql.Statement;
public class DeleteUserTest {
public static void main(String[] args) {
try {
Connection con=JDBCUils.getConnection();
Statement state= con.createStatement();
int rows=state.executeUpdate("delete from users where id=1101");
con.close();
state.close();
} catch (Exception e) {
e.printStackTrace();
}
}
}
package com.neusoft.text;
import java.beans.Transient;
import java.sql.Connection;
import java.sql.Date;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.Statement;
public class JDBCUils {
private static Connection con;
static {
try {
//1.
Class.forName("com.mysql.jdbc.Driver");
//2.
String url="jdbc:mysql://127.0.0.1:3306/users";
String username="root";
String password="admin";
//3.
con=DriverManager.getConnection(url,username,password);
}catch (Exception e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
//返回链接 connection对象
@Transient
public static Connection getConnection() {
return con;
}
}
package com.neusoft.text;
public class User {
private int id;
private String name;
private String password1;
private String email;
private String birthday;
public int getId() {
return id;
}
public void setId(int id) {
this.id = id;
}
public String getName() {
return name;
}
public void setName(String name) {
this.name = name;
}
public String getPassword1() {
return password1;
}
public void setPassword1(String password1) {
this.password1 = password1;
}
public String getEmail() {
return email;
}
public void setEmail(String email) {
this.email = email;
}
public String getBirthday() {
return birthday;
}
public void setBirthday(String birthday) {
this.birthday = birthday;
}
}
