import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.util.Scanner;
public class Tzengjia {
String userName;
String usesrPassword;
public String getUserName() {
return userName;
}
public void setUserName(String userName) {
this.userName = userName;
}
public String getUsesrPassword() {
return usesrPassword;
}
public void setUsesrPassword(String usesrPassword) {
this.usesrPassword = usesrPassword;
}
public static void main(String[] args) throws Exception {
try {
// 加载驱动
Class.forName("com.mysql.jdbc.Driver");
// 创建连接
Connection conn = DriverManager.getConnection("jdbc:mysql://192.168.9.2:3306/beautifybreast", "root", "admin");
// 写sql语句,此处为动态添加,未赋值
String sql = "insert into test (name,url) values(?,?,?)";
// 预编译的PrepareStatement
PreparedStatement pr = conn.prepareStatement(sql);
// Statement
java.sql.Statement st = conn.createStatement();
Scanner sc = new Scanner(System.in);
String userName = sc.next();
String userPassword = sc.next();
pr.setString(1, userName);
pr.setString(2, userPassword);
// 注意执行数据库插入、删除、修改(增删改)是用excuteUpdate();
// 执行查询语句时使用excuteQuery();
int rs = pr.executeUpdate();
int rs1 = st.executeUpdate(sql);
if (rs > 0) {
System.out.println("preparestatement插入成功");
} else {
System.out.println("preparestatement失败");
}
if (rs1 > 0) {
System.out.println("stamtement插入成功");
} else {
System.out.println("statement失败");
}
// 使用Result获得结果集,如果有则输出到控制台。
//数据库查询,执行查询语句时使用excuteQuery();
String sql3 ="select * from test";
PreparedStatement pr1 = conn.prepareStatement(sql3);
ResultSet result = pr1.executeQuery();
//打印结果集,根据主键查询,结果只能是1条记录,可以根据字段序号和字段名查询。
if (result.next()) {
System.out.println(result.getString("name")+result.getString(3));
}
} catch (ClassNotFoundException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.util.Scanner;
public class Tzengjia {
String userName;
String usesrPassword;
public String getUserName() {
return userName;
}
public void setUserName(String userName) {
this.userName = userName;
}
public String getUsesrPassword() {
return usesrPassword;
}
public void setUsesrPassword(String usesrPassword) {
this.usesrPassword = usesrPassword;
}
public static void main(String[] args) throws Exception {
try {
// 加载驱动
Class.forName("com.mysql.jdbc.Driver");
// 创建连接
Connection conn = DriverManager.getConnection("jdbc:mysql://192.168.9.2:3306/beautifybreast", "root", "admin");
// 写sql语句,此处为动态添加,未赋值
String sql = "insert into test (name,url) values(?,?,?)";
// 预编译的PrepareStatement
PreparedStatement pr = conn.prepareStatement(sql);
// Statement
java.sql.Statement st = conn.createStatement();
Scanner sc = new Scanner(System.in);
String userName = sc.next();
String userPassword = sc.next();
pr.setString(1, userName);
pr.setString(2, userPassword);
// 注意执行数据库插入、删除、修改(增删改)是用excuteUpdate();
// 执行查询语句时使用excuteQuery();
int rs = pr.executeUpdate();
int rs1 = st.executeUpdate(sql);
if (rs > 0) {
System.out.println("preparestatement插入成功");
} else {
System.out.println("preparestatement失败");
}
if (rs1 > 0) {
System.out.println("stamtement插入成功");
} else {
System.out.println("statement失败");
}
// 使用Result获得结果集,如果有则输出到控制台。
//数据库查询,执行查询语句时使用excuteQuery();
String sql3 ="select * from test";
PreparedStatement pr1 = conn.prepareStatement(sql3);
ResultSet result = pr1.executeQuery();
//打印结果集,根据主键查询,结果只能是1条记录,可以根据字段序号和字段名查询。
if (result.next()) {
System.out.println(result.getString("name")+result.getString(3));
}
} catch (ClassNotFoundException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}