package com.fit.dao;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
public class DBManager {
// 加载驱动
static {
try {
Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
System.out.println("driver---reg----ok");
} catch (ClassNotFoundException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
public static void main(String[] args) {
// 创建连接
try {
Connection conn = DriverManager.getConnection(
"jdbc:sqlserver://localhost:1433;databaseName=stuMS", "sa",
"11fit");
System.out.println("connect---------ok!");
// 创建sql语句
// String sql="update stuInfo set stu_name ='萧峰' where stu_id='6'";
// String sql="select * from stuInfo";
String sql = "select count(*) from stuInfo where stu_id='123' and stu_age='23'";
// String sql="select sub_id,sub from sub";
// 创建Statement对象
Statement stmt = conn.createStatement();
// 执行sql
// stmt.executeUpdate(sql);
ResultSet rs = stmt.executeQuery(sql);
// while(rs.next()){//遍历查询得到的结果集
// System.out.print(rs.getString("sub_id"));
// System.out.println("\t"+rs.getString("sub"));
// }
if (rs.next()) {
if (rs.getInt(1) == 1) {
System.out.println("ok");
} else {
System.out.println("error");
}
}
// 释放资源
rs.close();
rs = null;
stmt.close();
stmt = null;
conn.close();
conn = null;
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
public class DBManager {
// 加载驱动
static {
try {
Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
System.out.println("driver---reg----ok");
} catch (ClassNotFoundException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
public static void main(String[] args) {
// 创建连接
try {
Connection conn = DriverManager.getConnection(
"jdbc:sqlserver://localhost:1433;databaseName=stuMS", "sa",
"11fit");
System.out.println("connect---------ok!");
// 创建sql语句
// String sql="update stuInfo set stu_name ='萧峰' where stu_id='6'";
// String sql="select * from stuInfo";
String sql = "select count(*) from stuInfo where stu_id='123' and stu_age='23'";
// String sql="select sub_id,sub from sub";
// 创建Statement对象
Statement stmt = conn.createStatement();
// 执行sql
// stmt.executeUpdate(sql);
ResultSet rs = stmt.executeQuery(sql);
// while(rs.next()){//遍历查询得到的结果集
// System.out.print(rs.getString("sub_id"));
// System.out.println("\t"+rs.getString("sub"));
// }
if (rs.next()) {
if (rs.getInt(1) == 1) {
System.out.println("ok");
} else {
System.out.println("error");
}
}
// 释放资源
rs.close();
rs = null;
stmt.close();
stmt = null;
conn.close();
conn = null;
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}