It’s been a long time since my last blog post. Here is my recent one on Medium: ProvenLogs is a simple yet performant logging service built…
I just wrote my first Atom extension called file-header. It allows you to customize, add, update and cooperate your authoring information in header…
I came across a problem on leetcode a few days ago. It asked me to implement a simple regex (regular expression) matcher which supports both . and *…
Here is my first Robocode robot – Age. No need to have an introduction, just have a try if you want. BTW, it uses anti-gravity motion. Continue reading...
Here is the Java program written by me to simulate the Brownian motion. In this prac, I tried to use double buffering to improve the performances, but actually it is triple buffering. That’s because the JPane has already implemented the double buffering, so plus mine own copy of buffer to store the background coordinate system Continue reading...
Many Java programmers are befuddled by the three methods repaint(), paint(Graphics), and update(Graphics). This is because they are designed to work in a wide variety of circumstances, and they interact in a non-obvious fashion. This happens in several contexts in Java, but GUIs are the most obvious. The designers of Java wanted Java programs to Continue reading...
1. Q: Does importing all classes in a package make my object file (.class or .jar) larger? A: No, import only tells the compiler where to look for symbols. 2. Q: Is it less efficient to import all classes than only the classes I need? A: No. The search for names is very efficient so Continue reading...
Last week, during the prac 2 of CS IB, we were asked to program in Java to build a simple client/server system in which the server takes “commands” from the client and executes them. Due to the time restriction, we were only asked to implement the server, and use telnet to act as client to Continue reading...
根本原因： 访问数据库的用户有登录权限，但无操作表的权限 解决办法： 1. 在[企业控制台]窗口–[树]子窗口–[安全性]子树–[登录]项里将你使用的登陆用户的默认数据库设为你所使用的数据库。 2. 在[企业控制台]窗口–[树]子窗口–[安全性]子树–[登录]项里新增一个登录用户（在其中选择SQL Server 身份验证、服务器角色和要访问的数据库），以后便可用些新增用户访问你勾选的数据库了。 大家在用java连接ms sql时可能会这样的问题 原因是sa用户为系统用户,它虽然能够登陆数据库，但是数据库里边的权限都是dbo的，所以，我们现在为这个数据库重新建立一个用户. 当然,这个情况只发生在java里边. .net是不会这样的. 只要新建立一个用户,再在权限那分配权限做好就行了.
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 |
public Connection getConnectionDB() { String driverName = "com.microsoft.jdbc.sqlserver.SQLServerDriver"; String ConnectionString = "jdbc:microsoft:sqlserver://localhost:1433; DatabaseName=test;"; String userName = "username"; String userPwd = "password"; try { Class.forName(driverName); con = DriverManager.getConnection(ConnectionString, userName, userPwd); //System.out.println("Connection Successful!"); } catch (Exception e) { e.printStackTrace(); } return con; } ConnectionDB prod = new ConnectionDB(); Connection con = prod.getConnectionDB(); CallableStatement callStmt = null; java.sql.Statement stat = null; java.sql.ResultSet rs = null; stat = con.createStatement(); String sql = "select * from table"; rs = stat.executeQuery(sql); |