package connectmysql;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
public class Connectsql {
public static void main(String[] args) {
String driver = "com.mysql.jdbc.Driver"; //驱动路径
String url = "jdbc:mysql://localhost:3306/test";//数据库地址
String user = "root"; //访问数据库的用户名
String password = "123456"; //用户密码
//数据删除
/*try{
String name = "tqt";
int i;
Class.forName(driver); //加载驱动
Connection con = DriverManager.getConnection(url, user, password);
if(!con.isClosed()){
System.out.println("链接数据库成功:");
String sql="delete from user_70 where name=?";
PreparedStatement query =con.prepareStatement(sql);
query.setString(1, name);
i=query.executeUpdate(); //影响的行数
System.out.println(i);
}
} catch (Exception e){
e.printStackTrace();
}*/
//数据修改
/*try{
String name = "tqt";
String address = "sichuan";
String pwd = "54188";
int i;
Class.forName(driver); //加载驱动
Connection con = DriverManager.getConnection(url, user, password);
if(!con.isClosed()){
System.out.println("链接数据库成功:");
String sql="update user_70 set address=?, password=? where name=?";
PreparedStatement query =con.prepareStatement(sql);
query.setString(1, address);
query.setString(2, pwd);
query.setString(3, name);
i=query.executeUpdate(); //影响的行数
System.out.println(i);
}
} catch (Exception e){
e.printStackTrace();
}*/
//数据插入
/*try{
String name = "tqt";
String address = "mianyang";
String pwd = "081200";
int i;
Class.forName(driver); //加载驱动
Connection con = DriverManager.getConnection(url, user, password);
if(!con.isClosed()){
System.out.println("链接数据库成功:");
String sql="insert into user_70(name, address, password)values(?, ?, ?)";
PreparedStatement query =con.prepareStatement(sql);
query.setString(1, name);
query.setString(2, address);
query.setString(3, pwd);
i=query.executeUpdate(); //影响的行数
System.out.println(i);
}
} catch (Exception e){
e.printStackTrace();
}*/
//数据查询
/*try{
Class.forName(driver); //加载驱动
Connection con = DriverManager.getConnection(url, user, password);
if(!con.isClosed()){
System.out.println("链接数据库成功:");
Statement st = con.createStatement(); //创建Statement对象
String sql="select * from user_70";
ResultSet rs = st.executeQuery(sql); //查询之后返回结果集
while(rs.next()){
System.out.println(rs.getString("name")+"\t"+rs.getString("address")+"\t"+rs.getString("password"));
}
rs.close();
}
con.close();
} catch (Exception e){
e.printStackTrace();
}*/
}
}
