当前位置：Gxlcms >
数据库问题 >
JDBC连接数据库(Java DataBase Connectivity,java)
JDBC连接数据库(Java DataBase Connectivity,java)
时间：2021-07-01 10:21:17
帮助过：18人阅读
Head18;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import com.mysql.jdbc.PreparedStatement;
public class JDBC {
public static void main(String[] args) {
//加载驱动
try {
Class.forName("com.mysql.jdbc.Driver"
);
System.out.println("加载驱动成功"
);
} catch (ClassNotFoundException e) {
e.printStackTrace();
}
//数据库连接
String url="jdbc:mysql://127.0.0.1:13306/lianxi1?user=root&password=123456"
+ "&useUnicode=true&characterEncoding=utf-8"
;
Connection con=
null;
try {
con=
DriverManager.getConnection(url);
System.out.println("数据库建立成功"
);
} catch (SQLException e) {
e.printStackTrace();
System.out.println("数据库建立失败"
);
}
//建立句柄
Statement stmt=
null;
try {
stmt=
con.createStatement();
System.out.println("建立句柄成功"
);
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
//操作句柄,插入语句
String sql="INSERT INTO bp1 VALUES (‘111‘,‘大饼‘,‘男‘,‘19930101‘,‘95033‘)"
;
try {
boolean bsql=
stmt.execute(sql);
if (bsql){
System.out.println("插入失败"
);
}else{
System.out.println("插入成功"
);
}
} catch (SQLException e) {
e.printStackTrace();
}
//操作句柄，查询语句
String sql1="select * from bp1"
;
try {
ResultSet rs=
stmt.executeQuery(sql1);
int col=
rs.getMetaData().getColumnCount();
while(rs.next()){
for (
int i = 1; i <= col; i++
) {
System.out.print(rs.getString(i) + "\t"
);
}
System.out.println(""
);
}
} catch (SQLException e) {
e.printStackTrace();
}
}
}
JDBC连接数据库(Java DataBase Connectivity,java)
标签：into count 数据库 meta red pre cti stat jdbc
