sqlResult result = new sqlResult(); Connection con = result.getConnection(); ResultSet rs = result.getResultSet(con); result.printResult(rs); result.cloze();
楼主可以仔细看一下csdn左边的树形结构,可以发现,java是一个“java技术”而不是“java语言”。你现在学的只不过是java技术中的一小部分--jsp,而jsp是做不到C++所能做到的功能的。楼主说的做界面“好得多”,是指开发更方便呢,还是更好看呢?如果是前者,是比C要好点,但也并不是java的强项,要说更好看,那么C++做出的界面绝对是最好看的(当然,会很麻烦)建议楼主看thinking in java, core java等书,你有C++基础,看这些书会很快的
thinking in java, core java这是基础.... 路还长着.一步一步来..学精了自然有钱途.
要掌握的话自然得先把html + java 学好,JSP里又有其内置对象;
书的话好象有本飞思科技的《JSP应用开发》,听说评价挺高的
import java.io.*;
import java.lang.*;public class sqlConnection{
private Connection con = null;
private Statement state = null;
private ResultSet rs = null;
private PreparedStatement pre = null; public Connection getConnection(){
try{
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver"); //注册驱动器
con = DriverManager.getConnection("jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=xjj","sa","");
//建立连接
}
catch(ClassNotFoundException e){
System.out.println("注册失败");
}
catch(SQLException e){
System.out.println("连接失败");
}
return con;
}
public ResultSet getResultSet(Connection con){
try{
state = con.createStatement();
//普通查询
}
catch(SQLException e){
System.out.println("连接失败");
}
try{
String sql = "select * from student";
String sql1 = "select 姓名,学号 from student where 年龄='22'";
String sql2 = "insert into student(姓名,学号,性别,年龄) values('WangBin','7110342','女','25')";
String sql3 = "update student set 年龄='30' where 姓名='ChenXu'";
// pre = con.prepareStatement(sql1); //预查询
// pre.setString(1,"姓名");
//pre.setString(2,"学号");
//rs=pre.executeQuery();
//int num = state.executeUpdate(sql3); //插入更新操作
rs = state.executeQuery(sql1);
}
catch(SQLException e){
System.out.println("结果失败");
}
return rs;
}
public void printResult(ResultSet rs){
try{
while(rs.next()){
//System.out.println(rs.getString("姓名")+" "+rs.getString("学号")+" "+rs.getString("性别")+" "+rs.getString("年龄"));
System.out.println(rs.getString(1)+" "+rs.getString(2));
//System.out.println(rs.getString(1)+" "+rs.getString(2)+" "+rs.getString(3)+" "+rs.getString(4));
}
}
catch(SQLException e){
System.out.println("打印显示失败");
e.printStackTrace();
}
}
public void cloze(){
try{
if(rs != null)
rs.close();
if(pre != null)
pre.close();
if(state != null)
state.close();
if(con != null)
con.close();
}
catch(SQLException e){
System.out.println("关闭出错");
}
}
public static void main(String[] args){
sqlResult result = new sqlResult();
Connection con = result.getConnection();
ResultSet rs = result.getResultSet(con);
result.printResult(rs);
result.cloze();
} }
至於連接sql2k 網上一搜 多的是
html., js, css, java不必很深入,但至少要有些了解,然后学jsp会很快
路还长着.一步一步来..学精了自然有钱途.