关于MyEclipse 连接SqlServer 返回数据
1.dao层下的连接数据库类
2.stu包下的学生类
3.sqljdbc4.jar连接SqlServer方法
jdbc提取地址: https://pan.baidu.com/s/14JmoLdqC1q0139an7zSdAg 提取码 2nir
源码地址: https://download.****.net/download/qq_15267865/12682781
dao连接数据库
package Dao;
import java.sql.Array;
import java.sql.Blob;
import java.sql.CallableStatement;
import java.sql.Clob;
import java.sql.Connection;
import java.sql.DatabaseMetaData;
import java.sql.DriverManager;
import java.sql.NClob;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLClientInfoException;
import java.sql.SQLException;
import java.sql.SQLWarning;
import java.sql.SQLXML;
import java.sql.Savepoint;
import java.sql.Statement;
import java.sql.Struct;
import java.util.ArrayList;
import java.util.List;
import java.util.Map;
import java.util.Properties;
import cc.MyMVC.servlet.Student;
public class SqlServer {
private Connection con;
private Statement sta;
private ResultSet rs;
private static Connection conn;
static ArrayList students = new ArrayList();//定义与初始化ArrayList数组,相当于定义数组,但是容量比数组大
/********************静态块可以提高效率
* @throws SQLException
* @throws ClassNotFoundException ***********/
public static void getConnection() throws ClassNotFoundException, SQLException{
conn = DriverManager.getConnection("jdbc:sqlserver://数据库地址;DatabaseName=数据库名称", 登录帐号,登录密码);
}
public static void Update(String s1) throws ClassNotFoundException, SQLException{
if(conn!=null)
{
getConnection();
}
else{
System.out.println("Connection fail!");
}
Statement stat = conn.createStatement();
int rs =stat.executeUpdate(s1);
}
public static void query(String s1) throws ClassNotFoundException, SQLException{
if(conn!=null)
{
getConnection();
}
else{
System.out.println("Connection fail!");
}
Statement stat = conn.createStatement();
ResultSet rs = stat.executeQuery(s1);//定义ResultSet类,用于接收获取的数据
while (rs.next())
{
//实例化VO
int i = 0;
i++;
Student student=new Student();
student.setName(rs.getString("姓名"));
student.setBanji(rs.getString("班级"));
student.setSex(rs.getString("性别"));
student.setTime(rs.getString("年龄"));
students.add(student);
}
stat.close();
}
public static void main(String[] args) throws SQLException, ClassNotFoundException {
conn = null;
getConnection();
if(conn!=null)
{
System.out.println("Connection Successful!"); //如果连接成功 控制台输出
}
else{
System.out.println("Connection fail!");
}
// String sql = "update t_person set NAME = NAME+'z' where PERSON_BM='10101' ";
String sql = "select top 2 name 姓名,ORG_ID 班级,SEX 性别,DUTYCODE-200 年龄 from t_person ";//SQL语句,选择数据表student中的所有数据
query(sql);
for(int i=0;i<students.size();i++)
{
Student student=(Student)students.get(i);
System.out.print(student.getName());
}
}
}
java类
package cc.MyMVC.servlet;
public class Student {
private String name;
private String time;
private String banji;
public String getBanji() {
return banji;
}
public void setBanji(String banji) {
this.banji = banji;
}
private String sex;
public String getName() {
return name;
}
public void setName(String name) {
this.name = name;
}
public String getTime() {
return time;
}
public void setTime(String time) {
this.time = time;
}
public String getSex() {
return sex;
}
public void setSex(String sex) {
this.sex = sex;
}
}