java连接数据库图解
java连接数据库及数据库的查询先建java工程:
点next,显示下图如图所示:输入 projectname:test1,点击finish建立工程
完成后如图所示:
下一步添加jar包:
下一步选择:Libraries,点Add External JARS...
选择以下文件:在baidu下载以下三个文件(jdbc3.0),添加就可以了。
添加完成之后:新建CLASS类
在name的后面输入:test,勾上public static void main(String[] args),最后点finish
输入如下代码:
数据库创建表:
create table test_dsg
(
missid varchar(5),
missname varchar(20)
)
插入记录:
insert into test_dsg values('01','张三')
insert into test_dsg values('02','李四')
insert into test_dsg values('03','测试')
insert into test_dsg values('04','小张')
insert into test_dsg values('05','小王')
insert into test_dsg values('06','小李') import java.sql.*;
public class test {
/**
* @param args
*/
public static void main(String[] args) {
try {
String sql = "select top 10 * from test_dsg order by missid"; Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
String url =
"jdbc:microsoft:sqlserver://168.10.10.86:1433;DatabaseName=Tele_Sale";
String user = "sa";
String password = "sd";
java.sql.Connection conn = (java.sql.Connection) DriverManager.getConnection(url, user, password);
System.out.println("数据库连接成功!");
Statement st = conn.createStatement();
ResultSet rs = st.executeQuery(sql);
while(rs.next()){
System.out.println("工号:"+rs.getString("missid")+" 姓名:"+rs.getString("missname"));
}
conn.close();
st.close();
}
catch (ClassNotFoundException e)
{
System.out.println("数据库连接失败:" + e.getMessage());
}
catch (SQLException ex)
{
System.out.println("SQLException: " + ex.getMessage());
System.out.println("SQLState: " + ex.getSQLState());
}
}
}
运行结果如下: