数据库代码编写

   driver = "com.mysql.jdbc.Driver";
url="jdbc://127.0.0.1:3306/sc" //sc为新建的数据库
user="root"
passwd = "root"//root为安装sql时的用户名及密码
1. 加载驱动
Class.forName(driver);
2. 获取连接
Connection conn = 
DriverManager.getConnection(url,user,passwd);
3. 预处理sql
PreparedStatement pstmt = 
conn.prepareStatement(sql);
//替换占位符
pstmt.setXXX
4. 执行sql(标准查询语言)
//更改： 增，删，修
int num = pstmt.executeUpdate();
//查询： 查
ResultSet rs = pstmt.executeQuery();
5. 如果有结果集处理结果集
while(rs.next()){
rs.getXXX()
}
6. 释放资源
rs.close();
pstmt.close();

conn.close();

//简单查询

package work1;
import java.sql.*;
public class QueryTest {
public static void main(String []args) {
//接受数据
String username="admin";
String password="admin";

try {
//1.加载驱动程序
Class.forName("com.mysql.jdbc.Driver");

try {
//2.连接数据库
String  connStr="jdbc:mysql://localhost:3306/test";
Connection conn=DriverManager.getConnection(connStr,"root","123456");
//3.取得Statement对象
Statement sm=conn.createStatement();
//4.执行sql
String sqlStr="select * from users where username='";
sqlStr=sqlStr+username+"' and password='"+password+"'";
ResultSet rs=sm.executeQuery(sqlStr);
//5.业务处理
if(rs.next()) System.out.println("数据库中存在该用户");

else System.out.println("用户名或密码不正确");
//6.关闭
sm.close();
conn.close();

} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}

} catch (ClassNotFoundException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}

}

//运行结果